package c.x.jy.dao.dao;

import c.x.jy.dao.entity.SysUserRoleEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;

import java.util.List;

/**
 * 用户与角色对应关系
 * 
 * @author amwhyh
 * @email xxx@xx.com
 * @date 2021-05-20 20:27:36
 */
@Mapper
public interface SysUserRoleDao extends BaseMapper<SysUserRoleEntity> {
    @Update("<script>   INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES   <foreach collection='list' item='item' index='index'  separator=','> (  #{item.userId},#{item.roleId}    )  </foreach> </script>  ")
    int insertbatths(List<SysUserRoleEntity> list);
}

